Tabela OrgUnitAccount

Definicja tabeli OrgUnitAccount

Name

OrgUnitAccount

Code

OrgUnitAccount

Comment

 


Lista kolumn tabeli OrgUnitAccount

Name

Code

OrgUnitAccountID

OrgUnitAccountID

AccountNo

AccountNo

AccountName

AccountName

StartDT

StartDT

StopDT

StopDT


Kolumna OrgUnitAccountID tabeli OrgUnitAccount

Definicja kolumny OrgUnitAccountID tabeli OrgUnitAccount

Name

OrgUnitAccountID

Code

OrgUnitAccountID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AccountNo tabeli OrgUnitAccount

Definicja kolumny AccountNo tabeli OrgUnitAccount

Name

AccountNo

Code

AccountNo

Data Type

VARCHAR2(48)

Mandatory

Yes

Comment

 


Kolumna AccountName tabeli OrgUnitAccount

Definicja kolumny AccountName tabeli OrgUnitAccount

Name

AccountName

Code

AccountName

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna StartDT tabeli OrgUnitAccount

Definicja kolumny StartDT tabeli OrgUnitAccount

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli OrgUnitAccount

Definicja kolumny StopDT tabeli OrgUnitAccount

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli OrgUnitAccount

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OrgUnitAccount

Definicja klucza Identifier_1 tabeli OrgUnitAccount

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment